/*
 Navicat Premium Data Transfer

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : erp

 Target Server Type    : MySQL
 Target Server Version : 80029
 File Encoding         : 65001

 Date: 12/10/2022 21:27:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_action
-- ----------------------------
DROP TABLE IF EXISTS `t_action`;
CREATE TABLE `t_action` (
  `actionId` bigint NOT NULL AUTO_INCREMENT,
  `actionName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`actionId`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_action
-- ----------------------------
BEGIN;
INSERT INTO `t_action` (`actionId`, `actionName`) VALUES (1, 'add');
INSERT INTO `t_action` (`actionId`, `actionName`) VALUES (2, 'delete');
INSERT INTO `t_action` (`actionId`, `actionName`) VALUES (3, 'update');
INSERT INTO `t_action` (`actionId`, `actionName`) VALUES (4, 'list');
COMMIT;

-- ----------------------------
-- Table structure for t_actiongroup
-- ----------------------------
DROP TABLE IF EXISTS `t_actiongroup`;
CREATE TABLE `t_actiongroup` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `actionId` bigint NOT NULL,
  `managerId` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_actiongroup
-- ----------------------------
BEGIN;
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (1, 1, 1);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (2, 2, 1);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (3, 3, 1);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (4, 4, 1);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (5, 1, 2);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (6, 2, 2);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (7, 3, 2);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (8, 4, 2);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (9, 1, 3);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (10, 2, 3);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (11, 3, 3);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (12, 4, 3);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (13, 1, 4);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (14, 2, 4);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (15, 3, 4);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (16, 4, 4);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (17, 1, 5);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (18, 2, 5);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (19, 3, 5);
INSERT INTO `t_actiongroup` (`id`, `actionId`, `managerId`) VALUES (20, 4, 5);
COMMIT;

-- ----------------------------
-- Table structure for t_cash
-- ----------------------------
DROP TABLE IF EXISTS `t_cash`;
CREATE TABLE `t_cash` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `createDateTime` datetime(6) DEFAULT NULL,
  `information` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `money` bigint DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1574665946235244547 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_cash
-- ----------------------------
BEGIN;
INSERT INTO `t_cash` (`id`, `createDateTime`, `information`, `money`, `name`, `type`) VALUES (1, NULL, '测试数据', 1, '测试数据', '测试数据');
INSERT INTO `t_cash` (`id`, `createDateTime`, `information`, `money`, `name`, `type`) VALUES (2, NULL, '测试数据', 1, '测试数据', '测试数据');
INSERT INTO `t_cash` (`id`, `createDateTime`, `information`, `money`, `name`, `type`) VALUES (3, NULL, '测试数据', 1, '测试数据', '测试数据');
INSERT INTO `t_cash` (`id`, `createDateTime`, `information`, `money`, `name`, `type`) VALUES (1574665946235244546, '2022-09-27 15:43:12.087000', '测试数据', 1, '测试数据', '测试数据');
COMMIT;

-- ----------------------------
-- Table structure for t_department
-- ----------------------------
DROP TABLE IF EXISTS `t_department`;
CREATE TABLE `t_department` (
  `id` bigint NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_department
-- ----------------------------
BEGIN;
INSERT INTO `t_department` (`id`, `name`) VALUES (1, '测试数据1');
INSERT INTO `t_department` (`id`, `name`) VALUES (2, '测试数据2');
INSERT INTO `t_department` (`id`, `name`) VALUES (3, '测试部门3');
INSERT INTO `t_department` (`id`, `name`) VALUES (4, '测试部门4');
COMMIT;

-- ----------------------------
-- Table structure for t_employee
-- ----------------------------
DROP TABLE IF EXISTS `t_employee`;
CREATE TABLE `t_employee` (
  `id` bigint NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `age` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_employee
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_financialjournal
-- ----------------------------
DROP TABLE IF EXISTS `t_financialjournal`;
CREATE TABLE `t_financialjournal` (
  `id` bigint NOT NULL,
  `userId` bigint NOT NULL,
  `dbTable` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `operation` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `details` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_financialjournal
-- ----------------------------
BEGIN;
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574756592367173634, 1, 't_payable', '保存', NULL, '2022-09-27 21:43:24');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574756592518168577, 1, 't_ledger', '更新', '2', '2022-09-27 21:43:24');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574756961025523714, 1, 't_payable', '保存', NULL, '2022-09-27 21:44:52');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574756961063272449, 1, 't_ledger', '更新', '2', '2022-09-27 21:44:52');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574757148460580866, 1, 't_ledger', '更新', '2', '2022-09-27 21:45:36');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574757148481552385, 1, 't_payable', '删除', '1574756592170041346', '2022-09-27 21:45:36');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574759109348147202, 1, 't_ledger', '更新', '2', '2022-09-27 21:53:24');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574759109692080130, 1, 't_payable', '更新', '1574756960983580673', '2022-09-27 21:53:24');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574759203023732737, 1, 't_ledger', '更新', '2', '2022-09-27 21:53:46');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574759203183116290, 1, 't_payable', '更新', '1574756960983580673', '2022-09-27 21:53:46');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574759255750328322, 1, 't_ledger', '更新', '2', '2022-09-27 21:53:59');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574759255850991617, 1, 't_payable', '更新', '1574756960983580673', '2022-09-27 21:53:59');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574759302135136258, 1, 't_ledger', '更新', '2', '2022-09-27 21:54:10');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1574759302244188162, 1, 't_payable', '更新', '1574756960983580673', '2022-09-27 21:54:10');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579027585592057858, 1, 't_ledger', '更新', '2', '2022-10-09 16:34:48');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579027585680138242, 1, 't_payable', '更新', '1574756960983580673', '2022-10-09 16:34:48');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579027627216330753, 1, 't_ledger', '更新', '2', '2022-10-09 16:34:58');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579027627367325698, 1, 't_payable', '更新', '1574756960983580673', '2022-10-09 16:34:58');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579029889317728258, 1, 't_payable', '保存', NULL, '2022-10-09 16:43:57');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579029889691021313, 1, 't_ledger', '更新', '2', '2022-10-09 16:43:57');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579030089180508162, 1, 't_payable', '保存', NULL, '2022-10-09 16:44:45');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579030089209868290, 1, 't_ledger', '更新', '2', '2022-10-09 16:44:45');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579114197818605570, 1, 't_payable', '保存', NULL, '2022-10-09 22:18:58');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579114197990572033, 1, 't_ledger', '更新', '2', '2022-10-09 22:18:58');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579114298020528130, 1, 't_payable', '保存', NULL, '2022-10-09 22:19:22');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579114298079248386, 1, 't_ledger', '更新', '2', '2022-10-09 22:19:22');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579114359248977922, 1, 't_payable', '保存', NULL, '2022-10-09 22:19:36');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579114359274143746, 1, 't_ledger', '更新', '2', '2022-10-09 22:19:36');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579114908249870338, 1, 't_ledger', '更新', '2', '2022-10-09 22:21:47');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579114908316979202, 1, 't_payable', '删除', '1574756960983580673', '2022-10-09 22:21:47');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579121161340526594, 1, 't_receivable', '保存', NULL, '2022-10-09 22:46:38');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579121161420218370, 1, 't_ledger', '更新', '3', '2022-10-09 22:46:38');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579122039464206338, 1, 't_receivable', '保存', NULL, '2022-10-09 22:50:08');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579122039480983553, 1, 't_ledger', '更新', '3', '2022-10-09 22:50:08');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579122085702213633, 1, 't_receivable', '保存', NULL, '2022-10-09 22:50:19');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579122085727379457, 1, 't_ledger', '更新', '3', '2022-10-09 22:50:19');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579122133680857090, 1, 't_ledger', '更新', '3', '2022-10-09 22:50:30');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579122133714411522, 1, 't_receivable', '删除', '1579121161227280386', '2022-10-09 22:50:30');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579357834397659137, 1, 't_ledger', '更新', '3', '2022-10-10 14:27:05');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579358040509952002, 1, 't_receivable', '保存', NULL, '2022-10-10 14:27:55');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579358040560283649, 1, 't_ledger', '更新', '3', '2022-10-10 14:27:55');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579358088203382785, 1, 't_receivable', '保存', NULL, '2022-10-10 14:28:06');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579358088224354306, 1, 't_ledger', '更新', '3', '2022-10-10 14:28:06');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579367839209385985, 1, 't_ledger', '删除', '1', '2022-10-10 15:06:51');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1579369835802988545, 1, 't_ledger', '保存', NULL, '2022-10-10 15:14:47');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580087896038236161, 1, 't_ledger', '更新', '2', '2022-10-12 14:48:06');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580088008386863105, 1, 't_payable', '保存', NULL, '2022-10-12 14:48:32');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580088008437194754, 1, 't_ledger', '更新', '2', '2022-10-12 14:48:32');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580089987544702977, 1, 't_ledger', '更新', '2', '2022-10-12 14:56:24');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580089987574063105, 1, 't_payable', '删除', '1580088008378474498', '2022-10-12 14:56:24');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090167421624322, 1, 't_ledger', '更新', '3', '2022-10-12 14:57:07');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090167446790146, 1, 't_receivable', '删除', '1579358040488980481', '2022-10-12 14:57:07');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090256009519105, 1, 't_receivable', '保存', NULL, '2022-10-12 14:57:28');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090256101793793, 1, 't_ledger', '更新', '3', '2022-10-12 14:57:28');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090536675565569, 1, 't_receivable', '保存', NULL, '2022-10-12 14:58:35');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090536709120001, 1, 't_ledger', '更新', '3', '2022-10-12 14:58:35');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090602786185217, 1, 't_receivable', '保存', NULL, '2022-10-12 14:58:51');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090602819739649, 1, 't_ledger', '更新', '3', '2022-10-12 14:58:51');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090644859248642, 1, 't_ledger', '更新', '2', '2022-10-12 14:59:01');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090644884414465, 1, 't_payable', '更新', '1579029889170927618', '2022-10-12 14:59:01');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090755769229314, 1, 't_ledger', '更新', '2', '2022-10-12 14:59:27');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090755899252738, 1, 't_payable', '更新', '1579029889170927618', '2022-10-12 14:59:28');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090788975534081, 1, 't_ledger', '更新', '2', '2022-10-12 14:59:35');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090789025865729, 1, 't_payable', '更新', '1579114298007945218', '2022-10-12 14:59:35');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090873528508418, 1, 't_ledger', '更新', '2', '2022-10-12 14:59:56');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090873566257153, 1, 't_payable', '更新', '1579114298007945218', '2022-10-12 14:59:56');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090920878006273, 1, 't_ledger', '更新', '2', '2022-10-12 15:00:07');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580090920894783490, 1, 't_payable', '更新', '1579114298007945218', '2022-10-12 15:00:07');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580183112204214274, 1, 't_ledger', '更新', '2', '2022-10-12 21:06:27');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580183112262934529, 1, 't_payable', '更新', '1579029889170927618', '2022-10-12 21:06:27');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580183143783129089, 1, 't_ledger', '更新', '2', '2022-10-12 21:06:35');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580183218995388418, 1, 't_payable', '保存', NULL, '2022-10-12 21:06:52');
INSERT INTO `t_financialjournal` (`id`, `userId`, `dbTable`, `operation`, `details`, `time`) VALUES (1580183219062497282, 1, 't_ledger', '更新', '2', '2022-10-12 21:06:52');
COMMIT;

-- ----------------------------
-- Table structure for t_goods
-- ----------------------------
DROP TABLE IF EXISTS `t_goods`;
CREATE TABLE `t_goods` (
  `id` bigint NOT NULL,
  `price` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `num` int NOT NULL,
  `createDateTime` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_goods
-- ----------------------------
BEGIN;
INSERT INTO `t_goods` (`id`, `price`, `name`, `num`, `createDateTime`) VALUES (1578617173411217409, 100, 'TeaCake', 10, '2022-10-13 00:00:00.000000');
INSERT INTO `t_goods` (`id`, `price`, `name`, `num`, `createDateTime`) VALUES (1578618081645805570, 80, 'MilkCake', 20, '2022-10-12 00:00:00.000000');
INSERT INTO `t_goods` (`id`, `price`, `name`, `num`, `createDateTime`) VALUES (1578618208166985730, 8, '肉松饼', 200, '2022-10-07 00:00:00.000000');
INSERT INTO `t_goods` (`id`, `price`, `name`, `num`, `createDateTime`) VALUES (1578618267986149378, 2, '小面包', 800, '2022-10-18 00:00:00.000000');
INSERT INTO `t_goods` (`id`, `price`, `name`, `num`, `createDateTime`) VALUES (1580088373907873794, 123, '测试数据', 123, '2022-10-06 00:00:00.000000');
COMMIT;

-- ----------------------------
-- Table structure for t_ledger
-- ----------------------------
DROP TABLE IF EXISTS `t_ledger`;
CREATE TABLE `t_ledger` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `money` bigint DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1579369835865903106 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_ledger
-- ----------------------------
BEGIN;
INSERT INTO `t_ledger` (`id`, `money`, `type`) VALUES (2, 2665, '应付账');
INSERT INTO `t_ledger` (`id`, `money`, `type`) VALUES (3, 1665, '应收账');
COMMIT;

-- ----------------------------
-- Table structure for t_mangergroup
-- ----------------------------
DROP TABLE IF EXISTS `t_mangergroup`;
CREATE TABLE `t_mangergroup` (
  `managerId` bigint NOT NULL AUTO_INCREMENT,
  `managerName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`managerId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_mangergroup
-- ----------------------------
BEGIN;
INSERT INTO `t_mangergroup` (`managerId`, `managerName`) VALUES (1, 'SupperAdministrator');
INSERT INTO `t_mangergroup` (`managerId`, `managerName`) VALUES (2, 'FinancialAdministrator');
INSERT INTO `t_mangergroup` (`managerId`, `managerName`) VALUES (3, 'LogisticsAdministrator');
INSERT INTO `t_mangergroup` (`managerId`, `managerName`) VALUES (4, 'HrAdministrator');
INSERT INTO `t_mangergroup` (`managerId`, `managerName`) VALUES (5, 'OrdinaryUsers');
COMMIT;

-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `createDateTime` datetime(6) DEFAULT NULL,
  `goods` varchar(255) NOT NULL,
  `money` bigint NOT NULL,
  `customer` varchar(255) NOT NULL,
  `number` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1578605921251213315 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of t_order
-- ----------------------------
BEGIN;
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1574704724366647297, '2022-10-05 00:00:00.000000', 'A', 10000, '测试数据', 0);
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1574709418115756033, '2022-10-12 00:00:00.000000', 'A', 10000, '', 0);
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1574709427276115970, '2022-10-12 00:00:00.000000', 'A', 10000, '', 0);
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1574709430761582594, '2022-10-12 00:00:00.000000', 'A', 10000, '', 0);
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1574709434645508097, '2022-10-12 00:00:00.000000', 'A', 10000, '', 0);
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1574709438449741826, '2022-10-12 00:00:00.000000', 'A', 10000, '', 0);
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1574709445609418753, '2022-10-12 00:00:00.000000', 'A', 10000, '', 0);
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1575467913039581186, '2022-10-12 00:00:00.000000', 'B', 20000, '', 0);
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1575470196510953474, '2022-10-12 00:00:00.000000', 'B', 20000, '', 0);
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1575470217444724737, '2022-10-12 00:00:00.000000', 'B', 20000, '', 0);
INSERT INTO `t_order` (`id`, `createDateTime`, `goods`, `money`, `customer`, `number`) VALUES (1578605921251213314, '2022-10-15 00:00:00.000000', 'B', 20000, '', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_payable
-- ----------------------------
DROP TABLE IF EXISTS `t_payable`;
CREATE TABLE `t_payable` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `contract` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `createDateTime` datetime(6) NOT NULL,
  `endDateTime` datetime(6) NOT NULL,
  `information` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `money` bigint NOT NULL,
  `status` int NOT NULL,
  `ledgerId` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1580183218978611203 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_payable
-- ----------------------------
BEGIN;
INSERT INTO `t_payable` (`id`, `company`, `contract`, `createDateTime`, `endDateTime`, `information`, `money`, `status`, `ledgerId`) VALUES (1579029889170927618, '测试数据1', '测试数据1', '2022-09-01 00:36:00.000000', '2022-10-22 00:00:00.000000', '测试数据1', 1111, 0, 2);
INSERT INTO `t_payable` (`id`, `company`, `contract`, `createDateTime`, `endDateTime`, `information`, `money`, `status`, `ledgerId`) VALUES (1579030089167925250, '测试数据2', '测试数据2', '2022-10-03 00:00:00.000000', '2022-10-28 00:00:00.000000', '测试数据2', 222, 0, 2);
INSERT INTO `t_payable` (`id`, `company`, `contract`, `createDateTime`, `endDateTime`, `information`, `money`, `status`, `ledgerId`) VALUES (1579114197722136577, '测试数据3', '测试数据3', '2022-10-03 00:00:00.000000', '2022-10-15 00:00:00.000000', '测试数据3', 333, 0, 2);
INSERT INTO `t_payable` (`id`, `company`, `contract`, `createDateTime`, `endDateTime`, `information`, `money`, `status`, `ledgerId`) VALUES (1579114298007945218, '测试数据4', '测试数据4', '2022-10-04 00:00:00.000000', '2022-10-22 00:00:00.000000', '测试数据4', 444, 0, 2);
INSERT INTO `t_payable` (`id`, `company`, `contract`, `createDateTime`, `endDateTime`, `information`, `money`, `status`, `ledgerId`) VALUES (1580183218978611202, '测试数据5', '测试数据5', '2022-10-05 00:00:00.000000', '2022-10-21 00:00:00.000000', '测试数据5', 555, 0, 2);
COMMIT;

-- ----------------------------
-- Table structure for t_product
-- ----------------------------
DROP TABLE IF EXISTS `t_product`;
CREATE TABLE `t_product` (
  `id` bigint NOT NULL,
  `productName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `price` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_product
-- ----------------------------
BEGIN;
INSERT INTO `t_product` (`id`, `productName`, `price`) VALUES (1, '1', '1');
INSERT INTO `t_product` (`id`, `productName`, `price`) VALUES (2, '2', '2');
COMMIT;

-- ----------------------------
-- Table structure for t_purchase
-- ----------------------------
DROP TABLE IF EXISTS `t_purchase`;
CREATE TABLE `t_purchase` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `createDateTime` datetime(6) DEFAULT NULL,
  `goods` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `money` bigint NOT NULL,
  `market` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `number` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1578613133344358403 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_purchase
-- ----------------------------
BEGIN;
INSERT INTO `t_purchase` (`id`, `createDateTime`, `goods`, `money`, `market`, `number`) VALUES (1578610250699882498, '2022-10-05 00:00:00.000000', 'Tea', 2000, '测试数据', 0);
INSERT INTO `t_purchase` (`id`, `createDateTime`, `goods`, `money`, `market`, `number`) VALUES (1578610331779973122, '2022-09-10 00:00:00.000000', 'Tea', 10000, '', 0);
INSERT INTO `t_purchase` (`id`, `createDateTime`, `goods`, `money`, `market`, `number`) VALUES (1578610358216671234, NULL, 'Sugar', 10000, '', 0);
INSERT INTO `t_purchase` (`id`, `createDateTime`, `goods`, `money`, `market`, `number`) VALUES (1578610376508030977, NULL, 'Sugar', 20000, '', 0);
INSERT INTO `t_purchase` (`id`, `createDateTime`, `goods`, `money`, `market`, `number`) VALUES (1578610451191808001, NULL, 'Sugar', 20000, '', 0);
INSERT INTO `t_purchase` (`id`, `createDateTime`, `goods`, `money`, `market`, `number`) VALUES (1578613015727685634, NULL, 'cake', 200, '', 0);
INSERT INTO `t_purchase` (`id`, `createDateTime`, `goods`, `money`, `market`, `number`) VALUES (1578613133344358402, NULL, 'Bread', 200, '', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_receivable
-- ----------------------------
DROP TABLE IF EXISTS `t_receivable`;
CREATE TABLE `t_receivable` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `contract` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `createDateTime` datetime(6) NOT NULL,
  `endDateTime` datetime(6) NOT NULL,
  `information` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `money` bigint NOT NULL,
  `status` int NOT NULL,
  `ledgerId` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1580090602765213698 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_receivable
-- ----------------------------
BEGIN;
INSERT INTO `t_receivable` (`id`, `company`, `contract`, `createDateTime`, `endDateTime`, `information`, `money`, `status`, `ledgerId`) VALUES (1579122085681242113, '测试数据3', '测试数据3', '2022-10-09 00:00:00.000000', '2022-10-21 00:00:00.000000', '测试数据3', 333, 0, 3);
INSERT INTO `t_receivable` (`id`, `company`, `contract`, `createDateTime`, `endDateTime`, `information`, `money`, `status`, `ledgerId`) VALUES (1579358088186605570, '测试数据2', '测试数据2', '2022-10-10 00:00:00.000000', '2022-10-21 00:00:00.000000', '测试数据2', 222, 0, 3);
INSERT INTO `t_receivable` (`id`, `company`, `contract`, `createDateTime`, `endDateTime`, `information`, `money`, `status`, `ledgerId`) VALUES (1580090255996936194, '测试数据1', '测试数据1', '2022-10-12 00:00:00.000000', '2022-10-13 00:00:00.000000', '测试数据1', 111, 0, 3);
INSERT INTO `t_receivable` (`id`, `company`, `contract`, `createDateTime`, `endDateTime`, `information`, `money`, `status`, `ledgerId`) VALUES (1580090536650399746, '测试数据4', '测试数据4', '2022-10-07 00:00:00.000000', '2022-10-13 00:00:00.000000', '测试数据4', 444, 0, 3);
INSERT INTO `t_receivable` (`id`, `company`, `contract`, `createDateTime`, `endDateTime`, `information`, `money`, `status`, `ledgerId`) VALUES (1580090602765213697, '测试数据5', '测试数据5', '2022-10-05 00:00:00.000000', '2022-10-14 00:00:00.000000', '测试数据5', 555, 0, 3);
COMMIT;

-- ----------------------------
-- Table structure for t_salary
-- ----------------------------
DROP TABLE IF EXISTS `t_salary`;
CREATE TABLE `t_salary` (
  `id` bigint NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `day` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `money` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_salary
-- ----------------------------
BEGIN;
INSERT INTO `t_salary` (`id`, `name`, `day`, `money`) VALUES (1, '测试数据1', '111', '111');
INSERT INTO `t_salary` (`id`, `name`, `day`, `money`) VALUES (2, '测试数据2', '222', '222');
INSERT INTO `t_salary` (`id`, `name`, `day`, `money`) VALUES (3, '测试数据3', '333', '333');
INSERT INTO `t_salary` (`id`, `name`, `day`, `money`) VALUES (4, '测试数据4', '444', '444');
COMMIT;

-- ----------------------------
-- Table structure for t_staff
-- ----------------------------
DROP TABLE IF EXISTS `t_staff`;
CREATE TABLE `t_staff` (
  `id` bigint NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_staff
-- ----------------------------
BEGIN;
INSERT INTO `t_staff` (`id`, `name`, `gender`, `phone`) VALUES (1, '测试数据1', '女', '111');
INSERT INTO `t_staff` (`id`, `name`, `gender`, `phone`) VALUES (2, '测试数据2', '女', '222');
INSERT INTO `t_staff` (`id`, `name`, `gender`, `phone`) VALUES (3, '测试数据3', '男', '333');
INSERT INTO `t_staff` (`id`, `name`, `gender`, `phone`) VALUES (4, '测试数据4', '男', '444');
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `idNumber` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `sex` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  `status` int DEFAULT NULL,
  `username` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `salt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1580183022496440323 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` (`id`, `idNumber`, `password`, `sex`, `status`, `username`, `salt`, `name`) VALUES (1, '111111111111111111', '3943a0755f8b1775039a864b0b5a7b55184239c7', '男', 0, '11111111111', '9a1ac6146845c1f99f76f9930816a24b', '超级管理员');
INSERT INTO `t_user` (`id`, `idNumber`, `password`, `sex`, `status`, `username`, `salt`, `name`) VALUES (1573590895872290817, '333333333333333333', '4177612bfa54f31e896f02642aeed671913fe801', '女', 0, '33333333333', '572bc36c165b725bf345ed03651c5840', '物流管理员');
INSERT INTO `t_user` (`id`, `idNumber`, `password`, `sex`, `status`, `username`, `salt`, `name`) VALUES (1574656545445150722, '222222222222222222', '68d50c33212b6ad4b1c90205c04b1f420ccdd227', '男', 1, '22222222222', '4792304b8f6d94010bcc2f517411d817', '财务管理员');
INSERT INTO `t_user` (`id`, `idNumber`, `password`, `sex`, `status`, `username`, `salt`, `name`) VALUES (1574656629717106690, '444444444444444444', '0596fd6abfaadded3578f249c696c4b4c12c40fe', '男', 0, '44444444444', 'ee05af362d0830e9c85a9f00d3cc118c', '人力资源管理员');
INSERT INTO `t_user` (`id`, `idNumber`, `password`, `sex`, `status`, `username`, `salt`, `name`) VALUES (1574656716102991873, '555555555555555555', '2cf0fb13b4dd8ba8bdb76c5d46714ccb3ae5bfd5', '男', 0, '55555555555', '14421cd8e45ec93731de55aab100ccef', '普通用户');
INSERT INTO `t_user` (`id`, `idNumber`, `password`, `sex`, `status`, `username`, `salt`, `name`) VALUES (1578717728741539841, '140107200110301718', 'c439acb52379be9570a5111da80f0706c335c080', '男', 0, '12312341234', '32017e2511c8ed55db8c798025f9a0b5', '曾睿');
COMMIT;

-- ----------------------------
-- Table structure for t_usergroup
-- ----------------------------
DROP TABLE IF EXISTS `t_usergroup`;
CREATE TABLE `t_usergroup` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `managerId` bigint NOT NULL,
  `userId` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1580183022571937795 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of t_usergroup
-- ----------------------------
BEGIN;
INSERT INTO `t_usergroup` (`id`, `managerId`, `userId`) VALUES (1, 1, 1);
INSERT INTO `t_usergroup` (`id`, `managerId`, `userId`) VALUES (1573591559599910914, 3, 1573590895872290817);
INSERT INTO `t_usergroup` (`id`, `managerId`, `userId`) VALUES (1574656545520648194, 2, 1574656545445150722);
INSERT INTO `t_usergroup` (`id`, `managerId`, `userId`) VALUES (1574656629796798466, 4, 1574656629717106690);
INSERT INTO `t_usergroup` (`id`, `managerId`, `userId`) VALUES (1574656716132352001, 1, 1574656716102991873);
INSERT INTO `t_usergroup` (`id`, `managerId`, `userId`) VALUES (1578717728817037313, 2, 1578717728741539841);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
